package com.game.majiang.vo;

import java.sql.SQLException;
import java.util.ArrayList;

import javax.sql.rowset.CachedRowSet;
import com.game.server.db.SqlHelper;

public class hallSlidingDrawingVo {

	
	public static ArrayList<String> checkhall(){
		
		ArrayList<String> list = new ArrayList<String>();
		String cmdText = "SELECT url FROM hallslidingdrawing WHERE state =0";
    	CachedRowSet rs = SqlHelper.getResultSet(cmdText);
    	try {
    		  while (rs.next())
	          {
    			  list.add(rs.getString(1));
	         }
		 } catch (SQLException e) {
			// TODO Auto-generated catch block
			 e.printStackTrace();
		 }

		return list;
		
		
		
	}
	
}
